package com.central.apps.dao.inspection;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;
@Mapper
public interface inspregionalDao {
    @Select("SELECT insaenum,abstract FROM gq_inspregion WHERE 1=1 AND insaenum NOT IN(SELECT insaenum FROM gq_planarea where inspplannum = #{inspplannum}) ")
    List<Map<String,Object>> getregionalHandler(@Param("inspplannum") String inspplannum);


    @Select("SELECT insaenum,abstract FROM gq_inspregion WHERE 1=1 AND insaenum NOT IN(select insaenum from gq_insptarea where insptasknum = #{insptasknum})" )
    IPage<Map<String,Object>> getregionaHandler(Page page, @Param("insptasknum") String insptasknum);

}
